ALTER TABLE [Nop_Order] 
ADD ShippingDate datetime NULL,
    ShippingSMS bit NOT NULL DEFAULT 0,
	ShippingAddInfo nvarchar(1000) NOT NULL DEFAULT N''
GO

ALTER TABLE [Nop_Order] 
ADD PaymentMethodFee decimal(4, 1) NOT NULL DEFAULT 0
GO

ALTER TABLE [Nop_Order] 
ADD Note1 nvarchar(max) NOT NULL DEFAULT '',
    Note2 nvarchar(max) NOT NULL DEFAULT '',
    Note3 nvarchar(max) NOT NULL DEFAULT ''
GO